﻿-- =============================================
-- System Name:    Pre-Contract
-- Component:      Create view named vw_NoFeedbackPreContract
-- Created By:     Leo Ren (leoren@wicresoft.com)
-- Created Date:   2011-6-7
-- =============================================
/****** Object:  View [dbo].[vw_NoFeedbackPreContract]    Script Date: 06/22/2011 14:59:46 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_NoFeedbackPreContract]'))
DROP VIEW [dbo].[vw_NoFeedbackPreContract]
GO
/****** Object:  View [dbo].[vw_NoFeedbackPreContract]    Script Date: 06/22/2011 14:59:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_NoFeedbackPreContract]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vw_NoFeedbackPreContract]
AS
SELECT     pc.PreContractID, pc.PreContractNo, pc.StatusID, pc.TypeID, pc.ProductID, pc.PromisedDate, pc.CEWPromised, pc.OrionPrice, pc.SalePrice, pc.SignDue, pc.SignActual, 
                      pc.ContractName, pc.ERPReceived, pc.OrionNo, pc.Delivered, pc.CurrentSituation, pc.BlackDate, pc.TradeMonth, pc.ModifiedDate, pc.ACRNo, pc.ASBorLucent, 
                      pc.Applicant, pc.ApplicantEmail, pc.Principal, pc.PrincipalEmail, pc.ProvinceID, pc.CATID, pc.BDID, pc.CustomerName, pc.CustomField01, pc.CustomField02, 
                      pc.CustomField03, pc.CustomField04, pc.DeliveryPercent, pc.AdvancedContract, pc.IsRisk, pc.DeliveryDate, pc.Flag, pc.IsDelay, pc.AdjustID, pc.SparePrice, 
                      pc.CFIPrice, pc.DeliveryPlan, pc.UpdateReason, pc.AOGDate, pc.TransferHistoryInfo, pc.SpecialApprove, pc.DeadlineOfTrying, pc.SalePrice / 1000000 AS CygnusME, 
                      pc.OrionPrice / 1000000 AS OrigonME, dc.DicItemValue, pr.ProductName
FROM         dbo.PreContractInfo AS pc LEFT OUTER JOIN
                      dbo.DicItem AS dc ON dc.DicItemID = pc.TypeID LEFT OUTER JOIN
                      dbo.Product AS pr ON pr.ProductID = pc.ProductID
WHERE     (pc.StatusID IN (10, 11)) AND (pc.PreContractID NOT IN
                          (SELECT     PreContractID
                            FROM          dbo.vw_FeedbackPreContract AS fpc))
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vw_NoFeedbackPreContract', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "pc"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 222
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "dc"
            Begin Extent = 
               Top = 6
               Left = 260
               Bottom = 125
               Right = 420
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "pr"
            Begin Extent = 
               Top = 6
               Left = 458
               Bottom = 125
               Right = 618
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vw_NoFeedbackPreContract'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vw_NoFeedbackPreContract', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vw_NoFeedbackPreContract'
GO
